Overview
Brought to you by YData
Dataset statistics
| Number of variables | 33 |
|---|---|
| Number of observations | 10000 |
| Missing cells | 780 |
| Missing cells (%) | 0.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.5 MiB |
| Average record size in memory | 264.0 B |
Variable types
| Text | 3 |
|---|---|
| DateTime | 5 |
| Numeric | 12 |
| Categorical | 13 |
MaturedIn 10 years is highly overall correlated with Policy Code and 2 other fields | High correlation |
MaturedIn 15 years is highly overall correlated with Policy Code and 1 other fields | High correlation |
MaturedIn 5 years is highly overall correlated with Policy Code and 2 other fields | High correlation |
Maturity Amount is highly overall correlated with Total Annual Premium and 3 other fields | High correlation |
Payment Frequency is highly overall correlated with Total Annual Premium and 2 other fields | High correlation |
Policy Code is highly overall correlated with MaturedIn 10 years and 4 other fields | High correlation |
Policy Type Code is highly overall correlated with MaturedIn 10 years and 3 other fields | High correlation |
Premium Amount is highly overall correlated with Total Annual Premium | High correlation |
Premium Payment Duration is highly overall correlated with Purchase Year and 1 other fields | High correlation |
Purchase Month is highly overall correlated with Purchase Quarter | High correlation |
Purchase Quarter is highly overall correlated with Purchase Month | High correlation |
Purchase Year is highly overall correlated with Premium Payment Duration and 1 other fields | High correlation |
RM ID is highly overall correlated with Sales Agent Code and 2 other fields | High correlation |
Sales Agent Code is highly overall correlated with RM ID and 2 other fields | High correlation |
State is highly overall correlated with RM ID and 2 other fields | High correlation |
Tenure (Years) is highly overall correlated with MaturedIn 10 years and 4 other fields | High correlation |
Total Annual Premium is highly overall correlated with Maturity Amount and 5 other fields | High correlation |
Total Premium Amount is highly overall correlated with Maturity Amount and 4 other fields | High correlation |
Total Premium Payable is highly overall correlated with Payment Frequency and 3 other fields | High correlation |
Total Premium paid is highly overall correlated with Maturity Amount and 6 other fields | High correlation |
Zonal Manager ID is highly overall correlated with RM ID and 2 other fields | High correlation |
profit/gain is highly overall correlated with Maturity Amount and 1 other fields | High correlation |
Policy Status is highly imbalanced (53.5%) | Imbalance |
Annualized ROI (%) has 780 (7.8%) missing values | Missing |
Sum Assured INR/Coverage Amount has unique values | Unique |
Total Premium Amount has unique values | Unique |
profit/gain has unique values | Unique |
Premium Payment Duration has 780 (7.8%) zeros | Zeros |
Total Premium paid has 780 (7.8%) zeros | Zeros |
Maturity Amount has 2668 (26.7%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-08 06:08:25.885480 |
|---|---|
| Analysis finished | 2025-11-08 06:09:27.075493 |
| Duration | 1 minute and 1.19 second |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
Policy Number
Text
| Distinct | 9938 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 9876 ? |
|---|---|
| Unique (%) | 98.8% |
Sample
| 1st row | TRS-POL-892387 |
|---|---|
| 2nd row | TRS-POL-603900 |
| 3rd row | TRS-POL-336174 |
| 4th row | TRS-POL-745853 |
| 5th row | TRS-POL-799138 |
| Value | Count | Frequency (%) |
| trs-pol-794631 | 2 | < 0.1% |
| trs-pol-382682 | 2 | < 0.1% |
| trs-pol-462694 | 2 | < 0.1% |
| trs-pol-314657 | 2 | < 0.1% |
| trs-pol-833719 | 2 | < 0.1% |
| trs-pol-347852 | 2 | < 0.1% |
| trs-pol-299262 | 2 | < 0.1% |
| trs-pol-248874 | 2 | < 0.1% |
| trs-pol-147304 | 2 | < 0.1% |
| trs-pol-728606 | 2 | < 0.1% |
| Other values (9928) | 9980 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 20000 | |
| T | 10000 | 7.1% |
| R | 10000 | 7.1% |
| S | 10000 | 7.1% |
| P | 10000 | 7.1% |
| O | 10000 | 7.1% |
| L | 10000 | 7.1% |
| 6 | 6234 | 4.5% |
| 2 | 6171 | 4.4% |
| 7 | 6131 | 4.4% |
| Other values (7) | 41464 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 140000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| T | 10000 | 7.1% |
| R | 10000 | 7.1% |
| S | 10000 | 7.1% |
| P | 10000 | 7.1% |
| O | 10000 | 7.1% |
| L | 10000 | 7.1% |
| 6 | 6234 | 4.5% |
| 2 | 6171 | 4.4% |
| 7 | 6131 | 4.4% |
| Other values (7) | 41464 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 140000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| T | 10000 | 7.1% |
| R | 10000 | 7.1% |
| S | 10000 | 7.1% |
| P | 10000 | 7.1% |
| O | 10000 | 7.1% |
| L | 10000 | 7.1% |
| 6 | 6234 | 4.5% |
| 2 | 6171 | 4.4% |
| 7 | 6131 | 4.4% |
| Other values (7) | 41464 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 140000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| T | 10000 | 7.1% |
| R | 10000 | 7.1% |
| S | 10000 | 7.1% |
| P | 10000 | 7.1% |
| O | 10000 | 7.1% |
| L | 10000 | 7.1% |
| 6 | 6234 | 4.5% |
| 2 | 6171 | 4.4% |
| 7 | 6131 | 4.4% |
| Other values (7) | 41464 |
Start Date
Date
| Distinct | 3237 |
|---|---|
| Distinct (%) | 32.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2015-07-24 00:00:00 |
|---|---|
| Maximum | 2024-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Last Paid Date
Date
| Distinct | 1841 |
|---|---|
| Distinct (%) | 18.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2016-03-28 00:00:00 |
|---|---|
| Maximum | 2025-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Tenure (Years)
Real number (ℝ)
High correlation
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18.1789 |
| Minimum | 10 |
|---|---|
| Maximum | 25 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 12 |
| median | 20 |
| Q3 | 20 |
| 95-th percentile | 25 |
| Maximum | 25 |
| Range | 15 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 5.4460867 |
|---|---|
| Coefficient of variation (CV) | 0.29958285 |
| Kurtosis | -1.2798103 |
| Mean | 18.1789 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | -0.32459948 |
| Sum | 181789 |
| Variance | 29.659861 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 20 | 4177 | |
| 25 | 2358 | |
| 10 | 1818 | |
| 12 | 1235 | 12.3% |
| 15 | 395 | 4.0% |
| 22 | 17 | 0.2% |
| Value | Count | Frequency (%) |
| 10 | 1818 | |
| 12 | 1235 | 12.3% |
| 15 | 395 | 4.0% |
| 20 | 4177 | |
| 22 | 17 | 0.2% |
| 25 | 2358 |
| Value | Count | Frequency (%) |
| 25 | 2358 | |
| 22 | 17 | 0.2% |
| 20 | 4177 | |
| 15 | 395 | 4.0% |
| 12 | 1235 | 12.3% |
| 10 | 1818 |
Date of Purchase
Date
| Distinct | 3430 |
|---|---|
| Distinct (%) | 34.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2015-07-24 00:00:00 |
|---|---|
| Maximum | 2025-07-23 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Customer ID
Text
| Distinct | 9945 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Unique
| Unique | 9890 ? |
|---|---|
| Unique (%) | 98.9% |
Sample
| 1st row | CUST-189349 |
|---|---|
| 2nd row | CUST-802812 |
| 3rd row | CUST-541584 |
| 4th row | CUST-192788 |
| 5th row | CUST-221834 |
| Value | Count | Frequency (%) |
| cust-788106 | 2 | < 0.1% |
| cust-293235 | 2 | < 0.1% |
| cust-527543 | 2 | < 0.1% |
| cust-716679 | 2 | < 0.1% |
| cust-869518 | 2 | < 0.1% |
| cust-670927 | 2 | < 0.1% |
| cust-384786 | 2 | < 0.1% |
| cust-584470 | 2 | < 0.1% |
| cust-867233 | 2 | < 0.1% |
| cust-906301 | 2 | < 0.1% |
| Other values (9935) | 9980 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 10000 | 9.1% |
| U | 10000 | 9.1% |
| S | 10000 | 9.1% |
| T | 10000 | 9.1% |
| - | 10000 | 9.1% |
| 4 | 6185 | 5.6% |
| 2 | 6170 | 5.6% |
| 5 | 6168 | 5.6% |
| 9 | 6168 | 5.6% |
| 6 | 6090 | 5.5% |
| Other values (5) | 29219 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 110000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 10000 | 9.1% |
| U | 10000 | 9.1% |
| S | 10000 | 9.1% |
| T | 10000 | 9.1% |
| - | 10000 | 9.1% |
| 4 | 6185 | 5.6% |
| 2 | 6170 | 5.6% |
| 5 | 6168 | 5.6% |
| 9 | 6168 | 5.6% |
| 6 | 6090 | 5.5% |
| Other values (5) | 29219 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 110000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 10000 | 9.1% |
| U | 10000 | 9.1% |
| S | 10000 | 9.1% |
| T | 10000 | 9.1% |
| - | 10000 | 9.1% |
| 4 | 6185 | 5.6% |
| 2 | 6170 | 5.6% |
| 5 | 6168 | 5.6% |
| 9 | 6168 | 5.6% |
| 6 | 6090 | 5.5% |
| Other values (5) | 29219 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 110000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 10000 | 9.1% |
| U | 10000 | 9.1% |
| S | 10000 | 9.1% |
| T | 10000 | 9.1% |
| - | 10000 | 9.1% |
| 4 | 6185 | 5.6% |
| 2 | 6170 | 5.6% |
| 5 | 6168 | 5.6% |
| 9 | 6168 | 5.6% |
| 6 | 6090 | 5.5% |
| Other values (5) | 29219 |
Sum Assured INR/Coverage Amount
Real number (ℝ)
Unique
| Distinct | 10000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1054222.3 |
| Minimum | 100316.82 |
|---|---|
| Maximum | 1999546.8 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 100316.82 |
|---|---|
| 5-th percentile | 196491.26 |
| Q1 | 577241.91 |
| median | 1059397.7 |
| Q3 | 1527198.5 |
| 95-th percentile | 1907294.4 |
| Maximum | 1999546.8 |
| Range | 1899229.9 |
| Interquartile range (IQR) | 949956.59 |
Descriptive statistics
| Standard deviation | 549260.89 |
|---|---|
| Coefficient of variation (CV) | 0.52101051 |
| Kurtosis | -1.2055452 |
| Mean | 1054222.3 |
| Median Absolute Deviation (MAD) | 475548.59 |
| Skewness | -0.0035187733 |
| Sum | 1.0542223 × 1010 |
| Variance | 3.0168752 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1296266.37 | 1 | < 0.1% |
| 1956818.39 | 1 | < 0.1% |
| 1714308.34 | 1 | < 0.1% |
| 1500822.07 | 1 | < 0.1% |
| 968973.06 | 1 | < 0.1% |
| 1813080.34 | 1 | < 0.1% |
| 1134756.63 | 1 | < 0.1% |
| 1139388.87 | 1 | < 0.1% |
| 1478517.37 | 1 | < 0.1% |
| 1252589.84 | 1 | < 0.1% |
| Other values (9990) | 9990 |
| Value | Count | Frequency (%) |
| 100316.82 | 1 | |
| 100333.64 | 1 | |
| 100632.55 | 1 | |
| 100665.03 | 1 | |
| 100709.94 | 1 | |
| 100828.11 | 1 | |
| 101628.27 | 1 | |
| 101648.77 | 1 | |
| 102350.25 | 1 | |
| 102430.36 | 1 |
| Value | Count | Frequency (%) |
| 1999546.76 | 1 | |
| 1999441.68 | 1 | |
| 1999264.17 | 1 | |
| 1998796.46 | 1 | |
| 1998525.18 | 1 | |
| 1998314.16 | 1 | |
| 1998311.26 | 1 | |
| 1998270.05 | 1 | |
| 1997605.61 | 1 | |
| 1997550.35 | 1 |
Premium Amount
Real number (ℝ)
High correlation
| Distinct | 9995 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52261.483 |
| Minimum | 5028.98 |
|---|---|
| Maximum | 99997.01 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 5028.98 |
|---|---|
| 5-th percentile | 9641.422 |
| Q1 | 28251.645 |
| median | 52362.055 |
| Q3 | 76051.84 |
| 95-th percentile | 95333.279 |
| Maximum | 99997.01 |
| Range | 94968.03 |
| Interquartile range (IQR) | 47800.195 |
Descriptive statistics
| Standard deviation | 27511.888 |
|---|---|
| Coefficient of variation (CV) | 0.52642762 |
| Kurtosis | -1.2063144 |
| Mean | 52261.483 |
| Median Absolute Deviation (MAD) | 23881.73 |
| Skewness | 0.011607776 |
| Sum | 5.2261483 × 108 |
| Variance | 7.5690399 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 63835.33 | 2 | < 0.1% |
| 58252.59 | 2 | < 0.1% |
| 41203.82 | 2 | < 0.1% |
| 52662.24 | 2 | < 0.1% |
| 20252.27 | 2 | < 0.1% |
| 90879.8 | 1 | < 0.1% |
| 55477.09 | 1 | < 0.1% |
| 41270.19 | 1 | < 0.1% |
| 59448.84 | 1 | < 0.1% |
| 56037.48 | 1 | < 0.1% |
| Other values (9985) | 9985 |
| Value | Count | Frequency (%) |
| 5028.98 | 1 | |
| 5055.75 | 1 | |
| 5060.84 | 1 | |
| 5066.79 | 1 | |
| 5082.21 | 1 | |
| 5089.12 | 1 | |
| 5093.81 | 1 | |
| 5096.33 | 1 | |
| 5096.9 | 1 | |
| 5109.71 | 1 |
| Value | Count | Frequency (%) |
| 99997.01 | 1 | |
| 99976.71 | 1 | |
| 99974.54 | 1 | |
| 99965.59 | 1 | |
| 99958.74 | 1 | |
| 99944.01 | 1 | |
| 99938.14 | 1 | |
| 99932.81 | 1 | |
| 99925.51 | 1 | |
| 99920.71 | 1 |
Payment Frequency
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Quarterly | |
|---|---|
| Monthly | |
| Annually |
Length
| Max length | 9 |
|---|---|
| Median length | 8 |
| Mean length | 8.0108 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Quarterly |
|---|---|
| 2nd row | Quarterly |
| 3rd row | Quarterly |
| 4th row | Quarterly |
| 5th row | Quarterly |
Common Values
| Value | Count | Frequency (%) |
| Quarterly | 3432 | |
| Monthly | 3324 | |
| Annually | 3244 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| quarterly | 3432 | |
| monthly | 3324 | |
| annually | 3244 |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 13244 | |
| y | 10000 | |
| n | 9812 | |
| r | 6864 | |
| t | 6756 | |
| a | 6676 | |
| u | 6676 | |
| Q | 3432 | 4.3% |
| e | 3432 | 4.3% |
| M | 3324 | 4.1% |
| Other values (3) | 9892 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80108 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 13244 | |
| y | 10000 | |
| n | 9812 | |
| r | 6864 | |
| t | 6756 | |
| a | 6676 | |
| u | 6676 | |
| Q | 3432 | 4.3% |
| e | 3432 | 4.3% |
| M | 3324 | 4.1% |
| Other values (3) | 9892 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80108 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 13244 | |
| y | 10000 | |
| n | 9812 | |
| r | 6864 | |
| t | 6756 | |
| a | 6676 | |
| u | 6676 | |
| Q | 3432 | 4.3% |
| e | 3432 | 4.3% |
| M | 3324 | 4.1% |
| Other values (3) | 9892 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80108 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 13244 | |
| y | 10000 | |
| n | 9812 | |
| r | 6864 | |
| t | 6756 | |
| a | 6676 | |
| u | 6676 | |
| Q | 3432 | 4.3% |
| e | 3432 | 4.3% |
| M | 3324 | 4.1% |
| Other values (3) | 9892 |
Underwriting expenses
Real number (ℝ)
| Distinct | 9938 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5270.0628 |
| Minimum | 500.6 |
|---|---|
| Maximum | 9999.78 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 500.6 |
|---|---|
| 5-th percentile | 971.745 |
| Q1 | 2853.765 |
| median | 5264.165 |
| Q3 | 7702.4975 |
| 95-th percentile | 9542.81 |
| Maximum | 9999.78 |
| Range | 9499.18 |
| Interquartile range (IQR) | 4848.7325 |
Descriptive statistics
| Standard deviation | 2774.4241 |
|---|---|
| Coefficient of variation (CV) | 0.52644991 |
| Kurtosis | -1.2283104 |
| Mean | 5270.0628 |
| Median Absolute Deviation (MAD) | 2422.77 |
| Skewness | -0.0086640626 |
| Sum | 52700628 |
| Variance | 7697429.1 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8312.83 | 2 | < 0.1% |
| 6058.55 | 2 | < 0.1% |
| 9036.62 | 2 | < 0.1% |
| 2861.03 | 2 | < 0.1% |
| 1976.24 | 2 | < 0.1% |
| 6276.62 | 2 | < 0.1% |
| 1654.9 | 2 | < 0.1% |
| 6541.24 | 2 | < 0.1% |
| 6407.7 | 2 | < 0.1% |
| 7090.82 | 2 | < 0.1% |
| Other values (9928) | 9980 |
| Value | Count | Frequency (%) |
| 500.6 | 1 | |
| 500.7 | 1 | |
| 501.09 | 1 | |
| 501.27 | 1 | |
| 502.19 | 1 | |
| 502.21 | 1 | |
| 502.29 | 1 | |
| 502.37 | 1 | |
| 503.83 | 1 | |
| 504.06 | 1 |
| Value | Count | Frequency (%) |
| 9999.78 | 1 | |
| 9998.66 | 1 | |
| 9998.65 | 1 | |
| 9998.47 | 1 | |
| 9998.31 | 1 | |
| 9997.82 | 1 | |
| 9997.47 | 1 | |
| 9996.08 | 1 | |
| 9994.77 | 1 | |
| 9994.62 | 1 |
Sales Agent Code
Categorical
High correlation
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| AGT-6578 | |
|---|---|
| AGT-3567 | |
| AGT-3488 | |
| AGT-3150 | |
| AGT-2345 | |
| Other values (17) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | AGT-6578 |
|---|---|
| 2nd row | AGT-6578 |
| 3rd row | AGT-6578 |
| 4th row | AGT-6578 |
| 5th row | AGT-6578 |
Common Values
| Value | Count | Frequency (%) |
| AGT-6578 | 1221 | |
| AGT-3567 | 1120 | |
| AGT-3488 | 1009 | 10.1% |
| AGT-3150 | 819 | 8.2% |
| AGT-2345 | 637 | 6.4% |
| AGT-5980 | 612 | 6.1% |
| AGT-3465 | 550 | 5.5% |
| AGT-4456 | 512 | 5.1% |
| AGT-5467 | 463 | 4.6% |
| AGT-7898 | 458 | 4.6% |
| Other values (12) | 2599 |
Length
| Value | Count | Frequency (%) |
| agt-6578 | 1221 | |
| agt-3567 | 1120 | |
| agt-3488 | 1009 | 10.1% |
| agt-3150 | 819 | 8.2% |
| agt-2345 | 637 | 6.4% |
| agt-5980 | 612 | 6.1% |
| agt-3465 | 550 | 5.5% |
| agt-4456 | 512 | 5.1% |
| agt-5467 | 463 | 4.6% |
| agt-7898 | 458 | 4.6% |
| Other values (12) | 2599 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 10000 | |
| G | 10000 | |
| T | 10000 | |
| - | 10000 | |
| 5 | 7322 | |
| 4 | 5784 | |
| 8 | 5703 | |
| 3 | 4385 | |
| 6 | 3967 | 5.0% |
| 9 | 3687 | 4.6% |
| Other values (4) | 9152 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 10000 | |
| G | 10000 | |
| T | 10000 | |
| - | 10000 | |
| 5 | 7322 | |
| 4 | 5784 | |
| 8 | 5703 | |
| 3 | 4385 | |
| 6 | 3967 | 5.0% |
| 9 | 3687 | 4.6% |
| Other values (4) | 9152 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 10000 | |
| G | 10000 | |
| T | 10000 | |
| - | 10000 | |
| 5 | 7322 | |
| 4 | 5784 | |
| 8 | 5703 | |
| 3 | 4385 | |
| 6 | 3967 | 5.0% |
| 9 | 3687 | 4.6% |
| Other values (4) | 9152 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 10000 | |
| G | 10000 | |
| T | 10000 | |
| - | 10000 | |
| 5 | 7322 | |
| 4 | 5784 | |
| 8 | 5703 | |
| 3 | 4385 | |
| 6 | 3967 | 5.0% |
| 9 | 3687 | 4.6% |
| Other values (4) | 9152 |
Purchase Month
Categorical
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| December | |
|---|---|
| March | |
| August | |
| January | |
| July | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.165 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | April |
|---|---|
| 2nd row | April |
| 3rd row | August |
| 4th row | November |
| 5th row | June |
Common Values
| Value | Count | Frequency (%) |
| December | 892 | |
| March | 874 | |
| August | 866 | |
| January | 855 | |
| July | 841 | |
| November | 840 | |
| October | 828 | |
| May | 827 | |
| April | 825 | |
| September | 817 | |
| Other values (2) | 1535 |
Length
| Value | Count | Frequency (%) |
| december | 892 | |
| march | 874 | |
| august | 866 | |
| january | 855 | |
| july | 841 | |
| november | 840 | |
| october | 828 | |
| may | 827 | |
| april | 825 | |
| september | 817 | |
| Other values (2) | 1535 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9170 | |
| r | 7423 | |
| u | 4963 | 8.1% |
| a | 4157 | 6.7% |
| b | 4123 | 6.7% |
| y | 3269 | 5.3% |
| c | 2594 | 4.2% |
| m | 2549 | 4.1% |
| t | 2511 | 4.1% |
| J | 2485 | 4.0% |
| Other values (16) | 18406 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 61650 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 9170 | |
| r | 7423 | |
| u | 4963 | 8.1% |
| a | 4157 | 6.7% |
| b | 4123 | 6.7% |
| y | 3269 | 5.3% |
| c | 2594 | 4.2% |
| m | 2549 | 4.1% |
| t | 2511 | 4.1% |
| J | 2485 | 4.0% |
| Other values (16) | 18406 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 61650 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 9170 | |
| r | 7423 | |
| u | 4963 | 8.1% |
| a | 4157 | 6.7% |
| b | 4123 | 6.7% |
| y | 3269 | 5.3% |
| c | 2594 | 4.2% |
| m | 2549 | 4.1% |
| t | 2511 | 4.1% |
| J | 2485 | 4.0% |
| Other values (16) | 18406 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 61650 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 9170 | |
| r | 7423 | |
| u | 4963 | 8.1% |
| a | 4157 | 6.7% |
| b | 4123 | 6.7% |
| y | 3269 | 5.3% |
| c | 2594 | 4.2% |
| m | 2549 | 4.1% |
| t | 2511 | 4.1% |
| J | 2485 | 4.0% |
| Other values (16) | 18406 |
Purchase Quarter
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Q4 | |
|---|---|
| Q3 | |
| Q1 | |
| Q2 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Q2 |
|---|---|
| 2nd row | Q2 |
| 3rd row | Q3 |
| 4th row | Q4 |
| 5th row | Q2 |
Common Values
| Value | Count | Frequency (%) |
| Q4 | 2560 | |
| Q3 | 2524 | |
| Q1 | 2475 | |
| Q2 | 2441 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| q4 | 2560 | |
| q3 | 2524 | |
| q1 | 2475 | |
| q2 | 2441 |
Most occurring characters
| Value | Count | Frequency (%) |
| Q | 10000 | |
| 4 | 2560 | 12.8% |
| 3 | 2524 | 12.6% |
| 1 | 2475 | 12.4% |
| 2 | 2441 | 12.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 20000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| Q | 10000 | |
| 4 | 2560 | 12.8% |
| 3 | 2524 | 12.6% |
| 1 | 2475 | 12.4% |
| 2 | 2441 | 12.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 20000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| Q | 10000 | |
| 4 | 2560 | 12.8% |
| 3 | 2524 | 12.6% |
| 1 | 2475 | 12.4% |
| 2 | 2441 | 12.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 20000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| Q | 10000 | |
| 4 | 2560 | 12.8% |
| 3 | 2524 | 12.6% |
| 1 | 2475 | 12.4% |
| 2 | 2441 | 12.2% |
Purchase Year
Real number (ℝ)
High correlation
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2020.0509 |
| Minimum | 2015 |
|---|---|
| Maximum | 2025 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 2015 |
|---|---|
| 5-th percentile | 2016 |
| Q1 | 2018 |
| median | 2020 |
| Q3 | 2023 |
| 95-th percentile | 2025 |
| Maximum | 2025 |
| Range | 10 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.9134787 |
|---|---|
| Coefficient of variation (CV) | 0.0014422798 |
| Kurtosis | -1.1553952 |
| Mean | 2020.0509 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.004066033 |
| Sum | 20200509 |
| Variance | 8.488358 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2018 | 1092 | |
| 2022 | 1021 | |
| 2024 | 1019 | |
| 2016 | 994 | |
| 2019 | 990 | |
| 2021 | 983 | |
| 2020 | 977 | |
| 2023 | 974 | |
| 2017 | 953 | |
| 2025 | 548 |
| Value | Count | Frequency (%) |
| 2015 | 449 | |
| 2016 | 994 | |
| 2017 | 953 | |
| 2018 | 1092 | |
| 2019 | 990 | |
| 2020 | 977 | |
| 2021 | 983 | |
| 2022 | 1021 | |
| 2023 | 974 | |
| 2024 | 1019 |
| Value | Count | Frequency (%) |
| 2025 | 548 | |
| 2024 | 1019 | |
| 2023 | 974 | |
| 2022 | 1021 | |
| 2021 | 983 | |
| 2020 | 977 | |
| 2019 | 990 | |
| 2018 | 1092 | |
| 2017 | 953 | |
| 2016 | 994 |
| Distinct | 3428 |
|---|---|
| Distinct (%) | 34.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2016-07-24 00:00:00 |
|---|---|
| Maximum | 2026-07-23 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Policy Type Code
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| TR-ENDD989 | |
|---|---|
| TR-WHCD968 | |
| TR-UNCD988 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TR-UNCD988 |
|---|---|
| 2nd row | TR-UNCD988 |
| 3rd row | TR-UNCD988 |
| 4th row | TR-UNCD988 |
| 5th row | TR-UNCD988 |
Common Values
| Value | Count | Frequency (%) |
| TR-ENDD989 | 3383 | |
| TR-WHCD968 | 3347 | |
| TR-UNCD988 | 3270 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| tr-endd989 | 3383 | |
| tr-whcd968 | 3347 | |
| tr-uncd988 | 3270 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 13383 | |
| 9 | 13383 | |
| 8 | 13270 | |
| R | 10000 | |
| T | 10000 | |
| - | 10000 | |
| N | 6653 | |
| C | 6617 | |
| E | 3383 | 3.4% |
| W | 3347 | 3.3% |
| Other values (3) | 9964 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| D | 13383 | |
| 9 | 13383 | |
| 8 | 13270 | |
| R | 10000 | |
| T | 10000 | |
| - | 10000 | |
| N | 6653 | |
| C | 6617 | |
| E | 3383 | 3.4% |
| W | 3347 | 3.3% |
| Other values (3) | 9964 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| D | 13383 | |
| 9 | 13383 | |
| 8 | 13270 | |
| R | 10000 | |
| T | 10000 | |
| - | 10000 | |
| N | 6653 | |
| C | 6617 | |
| E | 3383 | 3.4% |
| W | 3347 | 3.3% |
| Other values (3) | 9964 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 100000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| D | 13383 | |
| 9 | 13383 | |
| 8 | 13270 | |
| R | 10000 | |
| T | 10000 | |
| - | 10000 | |
| N | 6653 | |
| C | 6617 | |
| E | 3383 | 3.4% |
| W | 3347 | 3.3% |
| Other values (3) | 9964 |
Policy Code
Categorical
High correlation
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| UGP-TRCD-9834 | |
|---|---|
| JSU-TRCD-9813 | |
| LGA-TRCD-9829 | |
| STP-TRCD-9812 | |
| ICP-TRCD-9832 | |
| Other values (3) |
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | UGP-TRCD-9834 |
|---|---|
| 2nd row | UGP-TRCD-9834 |
| 3rd row | UGP-TRCD-9834 |
| 4th row | UGP-TRCD-9834 |
| 5th row | UGP-TRCD-9834 |
Common Values
| Value | Count | Frequency (%) |
| UGP-TRCD-9834 | 3205 | |
| JSU-TRCD-9813 | 2358 | |
| LGA-TRCD-9829 | 1818 | |
| STP-TRCD-9812 | 1236 | 12.4% |
| ICP-TRCD-9832 | 972 | 9.7% |
| WLS-TRCD-9814 | 329 | 3.3% |
| RSE-TRCD-9856 | 65 | 0.7% |
| GWB-TRCD-9833 | 17 | 0.2% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ugp-trcd-9834 | 3205 | |
| jsu-trcd-9813 | 2358 | |
| lga-trcd-9829 | 1818 | |
| stp-trcd-9812 | 1236 | 12.4% |
| icp-trcd-9832 | 972 | 9.7% |
| wls-trcd-9814 | 329 | 3.3% |
| rse-trcd-9856 | 65 | 0.7% |
| gwb-trcd-9833 | 17 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 20000 | |
| 9 | 11818 | |
| T | 11236 | 8.6% |
| C | 10972 | 8.4% |
| R | 10065 | 7.7% |
| D | 10000 | 7.7% |
| 8 | 10000 | 7.7% |
| 3 | 6569 | 5.1% |
| U | 5563 | 4.3% |
| P | 5413 | 4.2% |
| Other values (14) | 28364 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 130000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| 9 | 11818 | |
| T | 11236 | 8.6% |
| C | 10972 | 8.4% |
| R | 10065 | 7.7% |
| D | 10000 | 7.7% |
| 8 | 10000 | 7.7% |
| 3 | 6569 | 5.1% |
| U | 5563 | 4.3% |
| P | 5413 | 4.2% |
| Other values (14) | 28364 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 130000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| 9 | 11818 | |
| T | 11236 | 8.6% |
| C | 10972 | 8.4% |
| R | 10065 | 7.7% |
| D | 10000 | 7.7% |
| 8 | 10000 | 7.7% |
| 3 | 6569 | 5.1% |
| U | 5563 | 4.3% |
| P | 5413 | 4.2% |
| Other values (14) | 28364 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 130000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 20000 | |
| 9 | 11818 | |
| T | 11236 | 8.6% |
| C | 10972 | 8.4% |
| R | 10065 | 7.7% |
| D | 10000 | 7.7% |
| 8 | 10000 | 7.7% |
| 3 | 6569 | 5.1% |
| U | 5563 | 4.3% |
| P | 5413 | 4.2% |
| Other values (14) | 28364 |
Policy Status
Categorical
Imbalance
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Active | |
|---|---|
| Surrendered | |
| Lapsed | 107 |
| Claimed | 37 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 7.2657 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Active |
|---|---|
| 2nd row | Active |
| 3rd row | Active |
| 4th row | Active |
| 5th row | Active |
Common Values
| Value | Count | Frequency (%) |
| Active | 7332 | |
| Surrendered | 2524 | 25.2% |
| Lapsed | 107 | 1.1% |
| Claimed | 37 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| active | 7332 | |
| surrendered | 2524 | 25.2% |
| lapsed | 107 | 1.1% |
| claimed | 37 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 15048 | |
| r | 7572 | |
| i | 7369 | |
| A | 7332 | |
| c | 7332 | |
| t | 7332 | |
| v | 7332 | |
| d | 5192 | 7.1% |
| u | 2524 | 3.5% |
| S | 2524 | 3.5% |
| Other values (8) | 3100 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 72657 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 15048 | |
| r | 7572 | |
| i | 7369 | |
| A | 7332 | |
| c | 7332 | |
| t | 7332 | |
| v | 7332 | |
| d | 5192 | 7.1% |
| u | 2524 | 3.5% |
| S | 2524 | 3.5% |
| Other values (8) | 3100 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 72657 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 15048 | |
| r | 7572 | |
| i | 7369 | |
| A | 7332 | |
| c | 7332 | |
| t | 7332 | |
| v | 7332 | |
| d | 5192 | 7.1% |
| u | 2524 | 3.5% |
| S | 2524 | 3.5% |
| Other values (8) | 3100 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 72657 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 15048 | |
| r | 7572 | |
| i | 7369 | |
| A | 7332 | |
| c | 7332 | |
| t | 7332 | |
| v | 7332 | |
| d | 5192 | 7.1% |
| u | 2524 | 3.5% |
| S | 2524 | 3.5% |
| Other values (8) | 3100 | 4.3% |
State
Categorical
High correlation
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Delhi | |
|---|---|
| Uttar Pradesh | |
| Sikkim | |
| Haryana | |
| Madhya Pradesh | |
| Other values (17) |
Length
| Max length | 16 |
|---|---|
| Median length | 13 |
| Mean length | 8.8023 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Delhi |
|---|---|
| 2nd row | Delhi |
| 3rd row | Delhi |
| 4th row | Delhi |
| 5th row | Delhi |
Common Values
| Value | Count | Frequency (%) |
| Delhi | 1221 | |
| Uttar Pradesh | 1120 | |
| Sikkim | 1009 | 10.1% |
| Haryana | 819 | 8.2% |
| Madhya Pradesh | 637 | 6.4% |
| Tamilnadu | 612 | 6.1% |
| Rajasthan | 550 | 5.5% |
| Bihar | 512 | 5.1% |
| Chandigarh | 463 | 4.6% |
| Uttarakhand | 458 | 4.6% |
| Other values (12) | 2599 |
Length
| Value | Count | Frequency (%) |
| pradesh | 2301 | |
| delhi | 1221 | 9.8% |
| uttar | 1120 | 9.0% |
| sikkim | 1009 | 8.1% |
| haryana | 819 | 6.6% |
| madhya | 637 | 5.1% |
| tamilnadu | 612 | 4.9% |
| rajasthan | 550 | 4.4% |
| bihar | 512 | 4.1% |
| chandigarh | 463 | 3.7% |
| Other values (14) | 3209 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 17899 | |
| h | 8562 | 9.7% |
| r | 7840 | 8.9% |
| d | 5240 | 6.0% |
| i | 5236 | 5.9% |
| e | 4402 | 5.0% |
| t | 4319 | 4.9% |
| n | 4169 | 4.7% |
| s | 3949 | 4.5% |
| k | 2992 | 3.4% |
| Other values (25) | 23415 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 88023 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 17899 | |
| h | 8562 | 9.7% |
| r | 7840 | 8.9% |
| d | 5240 | 6.0% |
| i | 5236 | 5.9% |
| e | 4402 | 5.0% |
| t | 4319 | 4.9% |
| n | 4169 | 4.7% |
| s | 3949 | 4.5% |
| k | 2992 | 3.4% |
| Other values (25) | 23415 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 88023 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 17899 | |
| h | 8562 | 9.7% |
| r | 7840 | 8.9% |
| d | 5240 | 6.0% |
| i | 5236 | 5.9% |
| e | 4402 | 5.0% |
| t | 4319 | 4.9% |
| n | 4169 | 4.7% |
| s | 3949 | 4.5% |
| k | 2992 | 3.4% |
| Other values (25) | 23415 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 88023 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 17899 | |
| h | 8562 | 9.7% |
| r | 7840 | 8.9% |
| d | 5240 | 6.0% |
| i | 5236 | 5.9% |
| e | 4402 | 5.0% |
| t | 4319 | 4.9% |
| n | 4169 | 4.7% |
| s | 3949 | 4.5% |
| k | 2992 | 3.4% |
| Other values (25) | 23415 |
RM ID
Categorical
High correlation
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| RMN7A3X1 | |
|---|---|
| RMC9F7L5 | |
| RMS4B9K2 | |
| RME2D5Q4 | |
| RMW8C6P3 |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | RMN7A3X1 |
|---|---|
| 2nd row | RMN7A3X1 |
| 3rd row | RMN7A3X1 |
| 4th row | RMN7A3X1 |
| 5th row | RMN7A3X1 |
Common Values
| Value | Count | Frequency (%) |
| RMN7A3X1 | 3799 | |
| RMC9F7L5 | 2018 | |
| RMS4B9K2 | 1661 | |
| RME2D5Q4 | 1509 | 15.1% |
| RMW8C6P3 | 1013 | 10.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| rmn7a3x1 | 3799 | |
| rmc9f7l5 | 2018 | |
| rms4b9k2 | 1661 | |
| rme2d5q4 | 1509 | 15.1% |
| rmw8c6p3 | 1013 | 10.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 10000 | 12.5% |
| M | 10000 | 12.5% |
| 7 | 5817 | 7.3% |
| 3 | 4812 | 6.0% |
| N | 3799 | 4.7% |
| A | 3799 | 4.7% |
| X | 3799 | 4.7% |
| 1 | 3799 | 4.7% |
| 9 | 3679 | 4.6% |
| 5 | 3527 | 4.4% |
| Other values (15) | 26969 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 10000 | 12.5% |
| M | 10000 | 12.5% |
| 7 | 5817 | 7.3% |
| 3 | 4812 | 6.0% |
| N | 3799 | 4.7% |
| A | 3799 | 4.7% |
| X | 3799 | 4.7% |
| 1 | 3799 | 4.7% |
| 9 | 3679 | 4.6% |
| 5 | 3527 | 4.4% |
| Other values (15) | 26969 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 10000 | 12.5% |
| M | 10000 | 12.5% |
| 7 | 5817 | 7.3% |
| 3 | 4812 | 6.0% |
| N | 3799 | 4.7% |
| A | 3799 | 4.7% |
| X | 3799 | 4.7% |
| 1 | 3799 | 4.7% |
| 9 | 3679 | 4.6% |
| 5 | 3527 | 4.4% |
| Other values (15) | 26969 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 10000 | 12.5% |
| M | 10000 | 12.5% |
| 7 | 5817 | 7.3% |
| 3 | 4812 | 6.0% |
| N | 3799 | 4.7% |
| A | 3799 | 4.7% |
| X | 3799 | 4.7% |
| 1 | 3799 | 4.7% |
| 9 | 3679 | 4.6% |
| 5 | 3527 | 4.4% |
| Other values (15) | 26969 |
Zonal Manager ID
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| ZMN8K2L1 | |
|---|---|
| ZMW3T7P8 | |
| ZMS5Q4R2 |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ZMN8K2L1 |
|---|---|
| 2nd row | ZMN8K2L1 |
| 3rd row | ZMN8K2L1 |
| 4th row | ZMN8K2L1 |
| 5th row | ZMN8K2L1 |
Common Values
| Value | Count | Frequency (%) |
| ZMN8K2L1 | 5817 | |
| ZMW3T7P8 | 2522 | |
| ZMS5Q4R2 | 1661 | 16.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| zmn8k2l1 | 5817 | |
| zmw3t7p8 | 2522 | |
| zms5q4r2 | 1661 | 16.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| Z | 10000 | |
| M | 10000 | |
| 8 | 8339 | |
| 2 | 7478 | |
| N | 5817 | 7.3% |
| K | 5817 | 7.3% |
| L | 5817 | 7.3% |
| 1 | 5817 | 7.3% |
| W | 2522 | 3.2% |
| 3 | 2522 | 3.2% |
| Other values (8) | 15871 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| Z | 10000 | |
| M | 10000 | |
| 8 | 8339 | |
| 2 | 7478 | |
| N | 5817 | 7.3% |
| K | 5817 | 7.3% |
| L | 5817 | 7.3% |
| 1 | 5817 | 7.3% |
| W | 2522 | 3.2% |
| 3 | 2522 | 3.2% |
| Other values (8) | 15871 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| Z | 10000 | |
| M | 10000 | |
| 8 | 8339 | |
| 2 | 7478 | |
| N | 5817 | 7.3% |
| K | 5817 | 7.3% |
| L | 5817 | 7.3% |
| 1 | 5817 | 7.3% |
| W | 2522 | 3.2% |
| 3 | 2522 | 3.2% |
| Other values (8) | 15871 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 80000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| Z | 10000 | |
| M | 10000 | |
| 8 | 8339 | |
| 2 | 7478 | |
| N | 5817 | 7.3% |
| K | 5817 | 7.3% |
| L | 5817 | 7.3% |
| 1 | 5817 | 7.3% |
| W | 2522 | 3.2% |
| 3 | 2522 | 3.2% |
| Other values (8) | 15871 |
Total Annual Premium
Real number (ℝ)
High correlation
| Distinct | 9999 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 296301.64 |
| Minimum | 5028.98 |
|---|---|
| Maximum | 1199964.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 5028.98 |
|---|---|
| 5-th percentile | 20035.538 |
| Q1 | 65387.482 |
| median | 175249.96 |
| Q3 | 381875.01 |
| 95-th percentile | 1029702.6 |
| Maximum | 1199964.1 |
| Range | 1194935.1 |
| Interquartile range (IQR) | 316487.53 |
Descriptive statistics
| Standard deviation | 314418.55 |
|---|---|
| Coefficient of variation (CV) | 1.0611435 |
| Kurtosis | 0.79217685 |
| Mean | 296301.64 |
| Median Absolute Deviation (MAD) | 130309.79 |
| Skewness | 1.3603017 |
| Sum | 2.9630164 × 109 |
| Variance | 9.8859025 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 255341.32 | 2 | < 0.1% |
| 24301.8 | 1 | < 0.1% |
| 237795.36 | 1 | < 0.1% |
| 672449.76 | 1 | < 0.1% |
| 80158.84 | 1 | < 0.1% |
| 346829.16 | 1 | < 0.1% |
| 168341.88 | 1 | < 0.1% |
| 98376.36 | 1 | < 0.1% |
| 306750.08 | 1 | < 0.1% |
| 75307 | 1 | < 0.1% |
| Other values (9989) | 9989 |
| Value | Count | Frequency (%) |
| 5028.98 | 1 | |
| 5093.81 | 1 | |
| 5096.33 | 1 | |
| 5170.37 | 1 | |
| 5172.51 | 1 | |
| 5173.39 | 1 | |
| 5180.41 | 1 | |
| 5206.56 | 1 | |
| 5234.17 | 1 | |
| 5258.39 | 1 |
| Value | Count | Frequency (%) |
| 1199964.12 | 1 | |
| 1199720.52 | 1 | |
| 1199587.08 | 1 | |
| 1199257.68 | 1 | |
| 1199193.72 | 1 | |
| 1198971.24 | 1 | |
| 1198892.52 | 1 | |
| 1198877.04 | 1 | |
| 1198677 | 1 | |
| 1198274.4 | 1 |
Total Premium Amount
Real number (ℝ)
High correlation Unique
| Distinct | 10000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5354518.2 |
| Minimum | 50289.8 |
|---|---|
| Maximum | 29993013 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 50289.8 |
|---|---|
| 5-th percentile | 305977.84 |
| Q1 | 1082487.5 |
| median | 2817877.2 |
| Q3 | 7257986.1 |
| 95-th percentile | 20050961 |
| Maximum | 29993013 |
| Range | 29942723 |
| Interquartile range (IQR) | 6175498.6 |
Descriptive statistics
| Standard deviation | 6133014.4 |
|---|---|
| Coefficient of variation (CV) | 1.1453905 |
| Kurtosis | 2.6149785 |
| Mean | 5354518.2 |
| Median Absolute Deviation (MAD) | 2154496.9 |
| Skewness | 1.7471532 |
| Sum | 5.3545182 × 1010 |
| Variance | 3.7613865 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10086746.4 | 1 | < 0.1% |
| 8360972.64 | 1 | < 0.1% |
| 570386.64 | 1 | < 0.1% |
| 1998433.8 | 1 | < 0.1% |
| 1235886 | 1 | < 0.1% |
| 13221302.4 | 1 | < 0.1% |
| 2897236.8 | 1 | < 0.1% |
| 1852450.8 | 1 | < 0.1% |
| 286908.48 | 1 | < 0.1% |
| 7224864.24 | 1 | < 0.1% |
| Other values (9990) | 9990 |
| Value | Count | Frequency (%) |
| 50289.8 | 1 | |
| 51733.9 | 1 | |
| 52065.6 | 1 | |
| 53070.3 | 1 | |
| 53676.5 | 1 | |
| 58897 | 1 | |
| 60457.6 | 1 | |
| 61013.6 | 1 | |
| 62810.04 | 1 | |
| 63273.96 | 1 |
| Value | Count | Frequency (%) |
| 29993013 | 1 | |
| 29989677 | 1 | |
| 29981442 | 1 | |
| 29974281 | 1 | |
| 29966925 | 1 | |
| 29956860 | 1 | |
| 29949351 | 1 | |
| 29940159 | 1 | |
| 29917530 | 1 | |
| 29917218 | 1 |
Premium Payment Duration
Real number (ℝ)
High correlation Zeros
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1219 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 780 |
| Zeros (%) | 7.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 3 |
| Q3 | 7 |
| 95-th percentile | 9 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.8913451 |
|---|---|
| Coefficient of variation (CV) | 0.7014593 |
| Kurtosis | -1.0120868 |
| Mean | 4.1219 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.41546815 |
| Sum | 41219 |
| Variance | 8.3598764 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 1560 | |
| 2 | 1530 | |
| 1 | 1339 | |
| 7 | 811 | |
| 0 | 780 | |
| 5 | 752 | |
| 6 | 749 | |
| 4 | 740 | |
| 8 | 714 | |
| 9 | 713 |
| Value | Count | Frequency (%) |
| 0 | 780 | |
| 1 | 1339 | |
| 2 | 1530 | |
| 3 | 1560 | |
| 4 | 740 | |
| 5 | 752 | |
| 6 | 749 | |
| 7 | 811 | |
| 8 | 714 | |
| 9 | 713 |
| Value | Count | Frequency (%) |
| 10 | 312 | 3.1% |
| 9 | 713 | |
| 8 | 714 | |
| 7 | 811 | |
| 6 | 749 | |
| 5 | 752 | |
| 4 | 740 | |
| 3 | 1560 | |
| 2 | 1530 | |
| 1 | 1339 |
Total Premium paid
Real number (ℝ)
High correlation Zeros
| Distinct | 9221 |
|---|---|
| Distinct (%) | 92.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1226279.8 |
| Minimum | 0 |
|---|---|
| Maximum | 11960249 |
| Zeros | 780 |
| Zeros (%) | 7.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 152425.55 |
| median | 501077.43 |
| Q3 | 1538262.9 |
| 95-th percentile | 5402427.5 |
| Maximum | 11960249 |
| Range | 11960249 |
| Interquartile range (IQR) | 1385837.3 |
Descriptive statistics
| Standard deviation | 1805280.1 |
|---|---|
| Coefficient of variation (CV) | 1.4721601 |
| Kurtosis | 7.1127732 |
| Mean | 1226279.8 |
| Median Absolute Deviation (MAD) | 430973.93 |
| Skewness | 2.545756 |
| Sum | 1.2262798 × 1010 |
| Variance | 3.2590362 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 780 | 7.8% |
| 3353775.12 | 1 | < 0.1% |
| 303767.52 | 1 | < 0.1% |
| 188071.53 | 1 | < 0.1% |
| 505025.64 | 1 | < 0.1% |
| 37201.32 | 1 | < 0.1% |
| 45901.74 | 1 | < 0.1% |
| 425432.16 | 1 | < 0.1% |
| 287158.32 | 1 | < 0.1% |
| 2113335.36 | 1 | < 0.1% |
| Other values (9211) | 9211 |
| Value | Count | Frequency (%) |
| 0 | 780 | |
| 5180.41 | 1 | < 0.1% |
| 5206.56 | 1 | < 0.1% |
| 5234.17 | 1 | < 0.1% |
| 5272.83 | 1 | < 0.1% |
| 5367.65 | 1 | < 0.1% |
| 5560.24 | 1 | < 0.1% |
| 6084.13 | 1 | < 0.1% |
| 6444.47 | 1 | < 0.1% |
| 6649.68 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 11960248.8 | 1 | |
| 11946362.4 | 1 | |
| 11777304 | 1 | |
| 11583998.4 | 1 | |
| 11460394.8 | 1 | |
| 11294230.8 | 1 | |
| 11179504.8 | 1 | |
| 10898515.2 | 1 | |
| 10778457.24 | 1 | |
| 10770740.4 | 1 |
Total Premium Payable
Real number (ℝ)
High correlation
| Distinct | 9940 |
|---|---|
| Distinct (%) | 99.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4128238.4 |
| Minimum | 0 |
|---|---|
| Maximum | 29608197 |
| Zeros | 61 |
| Zeros (%) | 0.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 163144.38 |
| Q1 | 749094.76 |
| median | 1950218.6 |
| Q3 | 5547364.8 |
| 95-th percentile | 15934677 |
| Maximum | 29608197 |
| Range | 29608197 |
| Interquartile range (IQR) | 4798270.1 |
Descriptive statistics
| Standard deviation | 5086430.9 |
|---|---|
| Coefficient of variation (CV) | 1.2321069 |
| Kurtosis | 3.8062448 |
| Mean | 4128238.4 |
| Median Absolute Deviation (MAD) | 1555287.4 |
| Skewness | 1.9681932 |
| Sum | 4.1282384 × 1010 |
| Variance | 2.587178 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 61 | 0.6% |
| 1271362.56 | 1 | < 0.1% |
| 2853544.32 | 1 | < 0.1% |
| 3362248.8 | 1 | < 0.1% |
| 4294501.12 | 1 | < 0.1% |
| 6141933.6 | 1 | < 0.1% |
| 698564.57 | 1 | < 0.1% |
| 1164427.68 | 1 | < 0.1% |
| 9959739.84 | 1 | < 0.1% |
| 577809.48 | 1 | < 0.1% |
| Other values (9930) | 9930 |
| Value | Count | Frequency (%) |
| 0 | 61 | |
| 7807.85 | 1 | < 0.1% |
| 8305.8 | 1 | < 0.1% |
| 10346.78 | 1 | < 0.1% |
| 11712.78 | 1 | < 0.1% |
| 16257.14 | 1 | < 0.1% |
| 17198.88 | 1 | < 0.1% |
| 17338.68 | 1 | < 0.1% |
| 19383.3 | 1 | < 0.1% |
| 19432.98 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 29608197 | 1 | |
| 28875321 | 1 | |
| 28768248 | 1 | |
| 28695093 | 1 | |
| 28538049.6 | 1 | |
| 28469756.16 | 1 | |
| 27880914.24 | 1 | |
| 27806673.6 | 1 | |
| 27785122.56 | 1 | |
| 27672789 | 1 |
Maturity Amount
Real number (ℝ)
High correlation Zeros
| Distinct | 7333 |
|---|---|
| Distinct (%) | 73.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4332541.2 |
| Minimum | 0 |
|---|---|
| Maximum | 34488129 |
| Zeros | 2668 |
| Zeros (%) | 26.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1521059.6 |
| Q3 | 5876414.8 |
| 95-th percentile | 19904692 |
| Maximum | 34488129 |
| Range | 34488129 |
| Interquartile range (IQR) | 5876414.8 |
Descriptive statistics
| Standard deviation | 6462753.7 |
|---|---|
| Coefficient of variation (CV) | 1.4916774 |
| Kurtosis | 4.5457543 |
| Mean | 4332541.2 |
| Median Absolute Deviation (MAD) | 1521059.6 |
| Skewness | 2.1504481 |
| Sum | 4.3325412 × 1010 |
| Variance | 4.1767186 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 2668 | 26.7% |
| 896638.58 | 1 | < 0.1% |
| 3686687.172 | 1 | < 0.1% |
| 2154442.284 | 1 | < 0.1% |
| 6717826.752 | 1 | < 0.1% |
| 2441177.136 | 1 | < 0.1% |
| 2467091.94 | 1 | < 0.1% |
| 3312469.608 | 1 | < 0.1% |
| 4339682.1 | 1 | < 0.1% |
| 4814870.052 | 1 | < 0.1% |
| Other values (7323) | 7323 |
| Value | Count | Frequency (%) |
| 0 | 2668 | |
| 52301.392 | 1 | < 0.1% |
| 53803.256 | 1 | < 0.1% |
| 54148.224 | 1 | < 0.1% |
| 55193.112 | 1 | < 0.1% |
| 61252.88 | 1 | < 0.1% |
| 62875.904 | 1 | < 0.1% |
| 63454.144 | 1 | < 0.1% |
| 65636.4918 | 1 | < 0.1% |
| 66121.2882 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 34488128.55 | 1 | |
| 34478658.3 | 1 | |
| 34470423.15 | 1 | |
| 34450389 | 1 | |
| 34441753.65 | 1 | |
| 34431182.85 | 1 | |
| 34405159.5 | 1 | |
| 34326102.75 | 1 | |
| 34291892.55 | 1 | |
| 34186205.25 | 1 |
Annualized ROI (%)
Text
Missing
| Distinct | 149 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 780 |
| Missing (%) | 7.8% |
| Memory size | 78.3 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 5.9921909 |
| Min length | 5 |
Unique
| Unique | 5 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 10.45% |
|---|---|
| 2nd row | 6.69% |
| 3rd row | 6.69% |
| 4th row | 4.45% |
| 5th row | 5.16% |
| Value | Count | Frequency (%) |
| 100.00 | 2307 | |
| 7.66 | 223 | 2.4% |
| 12.71 | 221 | 2.4% |
| 10.45 | 221 | 2.4% |
| 5.87 | 213 | 2.3% |
| 4.55 | 205 | 2.2% |
| 5.16 | 202 | 2.2% |
| 6.69 | 201 | 2.2% |
| 8.87 | 196 | 2.1% |
| 16.69 | 173 | 1.9% |
| Other values (139) | 5058 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 10991 | |
| % | 9220 | |
| . | 9220 | |
| 1 | 6095 | |
| 6 | 3132 | 5.7% |
| 5 | 2876 | 5.2% |
| 7 | 2550 | 4.6% |
| 4 | 2537 | 4.6% |
| - | 2307 | 4.2% |
| 8 | 1973 | 3.6% |
| Other values (3) | 4347 | 7.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 55248 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 10991 | |
| % | 9220 | |
| . | 9220 | |
| 1 | 6095 | |
| 6 | 3132 | 5.7% |
| 5 | 2876 | 5.2% |
| 7 | 2550 | 4.6% |
| 4 | 2537 | 4.6% |
| - | 2307 | 4.2% |
| 8 | 1973 | 3.6% |
| Other values (3) | 4347 | 7.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 55248 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 10991 | |
| % | 9220 | |
| . | 9220 | |
| 1 | 6095 | |
| 6 | 3132 | 5.7% |
| 5 | 2876 | 5.2% |
| 7 | 2550 | 4.6% |
| 4 | 2537 | 4.6% |
| - | 2307 | 4.2% |
| 8 | 1973 | 3.6% |
| Other values (3) | 4347 | 7.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 55248 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 10991 | |
| % | 9220 | |
| . | 9220 | |
| 1 | 6095 | |
| 6 | 3132 | 5.7% |
| 5 | 2876 | 5.2% |
| 7 | 2550 | 4.6% |
| 4 | 2537 | 4.6% |
| - | 2307 | 4.2% |
| 8 | 1973 | 3.6% |
| Other values (3) | 4347 | 7.9% |
profit/gain
Real number (ℝ)
High correlation Unique
| Distinct | 10000 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1021976.9 |
| Minimum | -29993013 |
|---|---|
| Maximum | 4498451.5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2668 |
| Negative (%) | 26.7% |
| Memory size | 78.3 KiB |
Quantile statistics
| Minimum | -29993013 |
|---|---|
| 5-th percentile | -9313602.8 |
| Q1 | -409882.61 |
| median | 111307.38 |
| Q3 | 527153.29 |
| 95-th percentile | 1910616.8 |
| Maximum | 4498451.5 |
| Range | 34491465 |
| Interquartile range (IQR) | 937035.9 |
Descriptive statistics
| Standard deviation | 4163831.9 |
|---|---|
| Coefficient of variation (CV) | -4.0742915 |
| Kurtosis | 14.195781 |
| Mean | -1021976.9 |
| Median Absolute Deviation (MAD) | 428687.35 |
| Skewness | -3.4807872 |
| Sum | -1.0219769 × 1010 |
| Variance | 1.7337496 × 1013 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -10086746.4 | 1 | < 0.1% |
| -8360972.64 | 1 | < 0.1% |
| -570386.64 | 1 | < 0.1% |
| -1998433.8 | 1 | < 0.1% |
| -1235886 | 1 | < 0.1% |
| -13221302.4 | 1 | < 0.1% |
| -2897236.8 | 1 | < 0.1% |
| -1852450.8 | 1 | < 0.1% |
| -286908.48 | 1 | < 0.1% |
| -7224864.24 | 1 | < 0.1% |
| Other values (9990) | 9990 |
| Value | Count | Frequency (%) |
| -29993013 | 1 | |
| -29966925 | 1 | |
| -29917218 | 1 | |
| -29804361 | 1 | |
| -29803695 | 1 | |
| -29681673 | 1 | |
| -29608197 | 1 | |
| -29535825 | 1 | |
| -29458872 | 1 | |
| -29042619 | 1 |
| Value | Count | Frequency (%) |
| 4498451.55 | 1 | |
| 4497216.3 | 1 | |
| 4496142.15 | 1 | |
| 4493529 | 1 | |
| 4492402.65 | 1 | |
| 4491023.85 | 1 | |
| 4487629.5 | 1 | |
| 4477317.75 | 1 | |
| 4472855.55 | 1 | |
| 4459070.25 | 1 |
Tenure Date
Date
| Distinct | 5538 |
|---|---|
| Distinct (%) | 55.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| Minimum | 2025-01-08 00:00:00 |
|---|---|
| Maximum | 2049-12-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
MaturedIn 5 years
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 8554 | |
| 1 | 1446 | 14.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 8554 | |
| 1 | 1446 | 14.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 8554 | |
| 1 | 1446 | 14.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 8554 | |
| 1 | 1446 | 14.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 8554 | |
| 1 | 1446 | 14.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 8554 | |
| 1 | 1446 | 14.5% |
MaturedIn 10 years
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 7871 | |
| 1 | 2129 | 21.3% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 7871 | |
| 1 | 2129 | 21.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7871 | |
| 1 | 2129 | 21.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7871 | |
| 1 | 2129 | 21.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7871 | |
| 1 | 2129 | 21.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7871 | |
| 1 | 2129 | 21.3% |
MaturedIn 15 years
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 78.3 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 7068 | |
| 1 | 2932 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 7068 | |
| 1 | 2932 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7068 | |
| 1 | 2932 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7068 | |
| 1 | 2932 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7068 | |
| 1 | 2932 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7068 | |
| 1 | 2932 |
Interactions
Correlations
| MaturedIn 10 years | MaturedIn 15 years | MaturedIn 5 years | Maturity Amount | Payment Frequency | Policy Code | Policy Status | Policy Type Code | Premium Amount | Premium Payment Duration | Purchase Month | Purchase Quarter | Purchase Year | RM ID | Sales Agent Code | State | Sum Assured INR/Coverage Amount | Tenure (Years) | Total Annual Premium | Total Premium Amount | Total Premium Payable | Total Premium paid | Underwriting expenses | Zonal Manager ID | profit/gain | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MaturedIn 10 years | 1.000 | 0.151 | 0.021 | 0.131 | 0.011 | 0.624 | 0.036 | 0.613 | 0.019 | 0.233 | 0.018 | 0.023 | 0.202 | 0.028 | 0.051 | 0.051 | 0.000 | 0.624 | 0.003 | 0.158 | 0.163 | 0.047 | 0.024 | 0.016 | 0.172 |
| MaturedIn 15 years | 0.151 | 1.000 | 0.264 | 0.085 | 0.000 | 0.527 | 0.035 | 0.374 | 0.000 | 0.308 | 0.024 | 0.029 | 0.378 | 0.087 | 0.174 | 0.174 | 0.000 | 0.527 | 0.000 | 0.109 | 0.134 | 0.098 | 0.010 | 0.088 | 0.038 |
| MaturedIn 5 years | 0.021 | 0.264 | 1.000 | 0.129 | 0.013 | 0.628 | 0.000 | 0.572 | 0.000 | 0.328 | 0.061 | 0.056 | 0.394 | 0.016 | 0.000 | 0.000 | 0.000 | 0.628 | 0.000 | 0.161 | 0.234 | 0.151 | 0.000 | 0.000 | 0.164 |
| Maturity Amount | 0.131 | 0.085 | 0.129 | 1.000 | 0.483 | 0.113 | 0.252 | 0.178 | 0.278 | 0.364 | 0.000 | 0.012 | -0.007 | 0.010 | 0.032 | 0.032 | -0.012 | 0.135 | 0.510 | 0.532 | 0.437 | 0.586 | 0.004 | 0.019 | 0.988 |
| Payment Frequency | 0.011 | 0.000 | 0.013 | 0.483 | 1.000 | 0.013 | 0.007 | 0.010 | 0.000 | 0.000 | 0.022 | 0.020 | 0.000 | 0.009 | 0.026 | 0.026 | 0.019 | 0.000 | 0.721 | 0.622 | 0.544 | 0.426 | 0.000 | 0.004 | 0.438 |
| Policy Code | 0.624 | 0.527 | 0.628 | 0.113 | 0.013 | 1.000 | 0.123 | 1.000 | 0.010 | 0.012 | 0.000 | 0.005 | 0.000 | 0.163 | 0.232 | 0.232 | 0.000 | 1.000 | 0.013 | 0.135 | 0.124 | 0.001 | 0.024 | 0.217 | 0.125 |
| Policy Status | 0.036 | 0.035 | 0.000 | 0.252 | 0.007 | 0.123 | 1.000 | 0.000 | 0.005 | 0.319 | 0.000 | 0.000 | 0.000 | 0.138 | 0.298 | 0.298 | 0.010 | 0.086 | 0.003 | 0.000 | 0.047 | 0.125 | 0.007 | 0.072 | 0.404 |
| Policy Type Code | 0.613 | 0.374 | 0.572 | 0.178 | 0.010 | 1.000 | 0.000 | 1.000 | 0.007 | 0.000 | 0.000 | 0.011 | 0.005 | 0.004 | 0.036 | 0.036 | 0.000 | 0.871 | 0.011 | 0.211 | 0.213 | 0.000 | 0.000 | 0.004 | 0.205 |
| Premium Amount | 0.019 | 0.000 | 0.000 | 0.278 | 0.000 | 0.010 | 0.005 | 0.007 | 1.000 | 0.010 | 0.009 | 0.003 | -0.015 | 0.015 | 0.006 | 0.006 | -0.007 | -0.009 | 0.526 | 0.499 | 0.463 | 0.387 | 0.008 | 0.023 | 0.236 |
| Premium Payment Duration | 0.233 | 0.308 | 0.328 | 0.364 | 0.000 | 0.012 | 0.319 | 0.000 | 0.010 | 1.000 | 0.073 | 0.120 | -0.827 | 0.023 | 0.033 | 0.033 | -0.009 | 0.018 | 0.004 | 0.008 | -0.190 | 0.596 | 0.015 | 0.016 | 0.359 |
| Purchase Month | 0.018 | 0.024 | 0.061 | 0.000 | 0.022 | 0.000 | 0.000 | 0.000 | 0.009 | 0.073 | 1.000 | 1.000 | 0.082 | 0.009 | 0.000 | 0.000 | 0.017 | 0.006 | 0.013 | 0.009 | 0.012 | 0.019 | 0.015 | 0.013 | 0.003 |
| Purchase Quarter | 0.023 | 0.029 | 0.056 | 0.012 | 0.020 | 0.005 | 0.000 | 0.011 | 0.003 | 0.120 | 1.000 | 1.000 | 0.133 | 0.012 | 0.000 | 0.000 | 0.022 | 0.007 | 0.005 | 0.017 | 0.005 | 0.028 | 0.008 | 0.006 | 0.000 |
| Purchase Year | 0.202 | 0.378 | 0.394 | -0.007 | 0.000 | 0.000 | 0.000 | 0.005 | -0.015 | -0.827 | 0.082 | 0.133 | 1.000 | 0.009 | 0.005 | 0.005 | 0.010 | -0.009 | -0.015 | -0.016 | 0.150 | -0.507 | -0.016 | 0.000 | -0.006 |
| RM ID | 0.028 | 0.087 | 0.016 | 0.010 | 0.009 | 0.163 | 0.138 | 0.004 | 0.015 | 0.023 | 0.009 | 0.012 | 0.009 | 1.000 | 0.999 | 0.999 | 0.000 | 0.108 | 0.009 | 0.017 | 0.000 | 0.000 | 0.000 | 1.000 | 0.021 |
| Sales Agent Code | 0.051 | 0.174 | 0.000 | 0.032 | 0.026 | 0.232 | 0.298 | 0.036 | 0.006 | 0.033 | 0.000 | 0.000 | 0.005 | 0.999 | 1.000 | 1.000 | 0.000 | 0.183 | 0.013 | 0.029 | 0.023 | 0.000 | 0.005 | 0.999 | 0.041 |
| State | 0.051 | 0.174 | 0.000 | 0.032 | 0.026 | 0.232 | 0.298 | 0.036 | 0.006 | 0.033 | 0.000 | 0.000 | 0.005 | 0.999 | 1.000 | 1.000 | 0.000 | 0.183 | 0.013 | 0.029 | 0.023 | 0.000 | 0.005 | 0.999 | 0.041 |
| Sum Assured INR/Coverage Amount | 0.000 | 0.000 | 0.000 | -0.012 | 0.019 | 0.000 | 0.010 | 0.000 | -0.007 | -0.009 | 0.017 | 0.022 | 0.010 | 0.000 | 0.000 | 0.000 | 1.000 | -0.007 | -0.014 | -0.015 | -0.012 | -0.019 | -0.009 | 0.000 | -0.012 |
| Tenure (Years) | 0.624 | 0.527 | 0.628 | 0.135 | 0.000 | 1.000 | 0.086 | 0.871 | -0.009 | 0.018 | 0.006 | 0.007 | -0.009 | 0.108 | 0.183 | 0.183 | -0.007 | 1.000 | -0.023 | 0.225 | 0.327 | 0.001 | 0.009 | 0.145 | 0.159 |
| Total Annual Premium | 0.003 | 0.000 | 0.000 | 0.510 | 0.721 | 0.013 | 0.003 | 0.011 | 0.526 | 0.004 | 0.013 | 0.005 | -0.015 | 0.009 | 0.013 | 0.013 | -0.014 | -0.023 | 1.000 | 0.963 | 0.888 | 0.736 | 0.002 | 0.010 | 0.423 |
| Total Premium Amount | 0.158 | 0.109 | 0.161 | 0.532 | 0.622 | 0.135 | 0.000 | 0.211 | 0.499 | 0.008 | 0.009 | 0.017 | -0.016 | 0.017 | 0.029 | 0.029 | -0.015 | 0.225 | 0.963 | 1.000 | 0.955 | 0.715 | 0.004 | 0.020 | 0.452 |
| Total Premium Payable | 0.163 | 0.134 | 0.234 | 0.437 | 0.544 | 0.124 | 0.047 | 0.213 | 0.463 | -0.190 | 0.012 | 0.005 | 0.150 | 0.000 | 0.023 | 0.023 | -0.012 | 0.327 | 0.888 | 0.955 | 1.000 | 0.544 | -0.000 | 0.000 | 0.367 |
| Total Premium paid | 0.047 | 0.098 | 0.151 | 0.586 | 0.426 | 0.001 | 0.125 | 0.000 | 0.387 | 0.596 | 0.019 | 0.028 | -0.507 | 0.000 | 0.000 | 0.000 | -0.019 | 0.001 | 0.736 | 0.715 | 0.544 | 1.000 | 0.006 | 0.000 | 0.523 |
| Underwriting expenses | 0.024 | 0.010 | 0.000 | 0.004 | 0.000 | 0.024 | 0.007 | 0.000 | 0.008 | 0.015 | 0.015 | 0.008 | -0.016 | 0.000 | 0.005 | 0.005 | -0.009 | 0.009 | 0.002 | 0.004 | -0.000 | 0.006 | 1.000 | 0.005 | 0.004 |
| Zonal Manager ID | 0.016 | 0.088 | 0.000 | 0.019 | 0.004 | 0.217 | 0.072 | 0.004 | 0.023 | 0.016 | 0.013 | 0.006 | 0.000 | 1.000 | 0.999 | 0.999 | 0.000 | 0.145 | 0.010 | 0.020 | 0.000 | 0.000 | 0.005 | 1.000 | 0.033 |
| profit/gain | 0.172 | 0.038 | 0.164 | 0.988 | 0.438 | 0.125 | 0.404 | 0.205 | 0.236 | 0.359 | 0.003 | 0.000 | -0.006 | 0.021 | 0.041 | 0.041 | -0.012 | 0.159 | 0.423 | 0.452 | 0.367 | 0.523 | 0.004 | 0.033 | 1.000 |
Missing values
Sample
| Policy Number | Start Date | Last Paid Date | Tenure (Years) | Date of Purchase | Customer ID | Sum Assured INR/Coverage Amount | Premium Amount | Payment Frequency | Underwriting expenses | Sales Agent Code | Purchase Month | Purchase Quarter | Purchase Year | Policy Anniversary Date | Policy Type Code | Policy Code | Policy Status | State | RM ID | Zonal Manager ID | Total Annual Premium | Total Premium Amount | Premium Payment Duration | Total Premium paid | Total Premium Payable | Maturity Amount | Annualized ROI (%) | profit/gain | Tenure Date | MaturedIn 5 years | MaturedIn 10 years | MaturedIn 15 years | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | TRS-POL-892387 | 18 April 2022 | 18 April 2025 | 20 | 18 April 2022 | CUST-189349 | 619301.17 | 42085.47 | Quarterly | 3335.88 | AGT-6578 | April | Q2 | 2022 | 18 April 2023 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 168341.88 | 3366837.6 | 3 | 505025.64 | 2861811.96 | 3686687.172 | 10.45% | 319849.572 | 18-04-2042 | 0 | 0 | 0 |
| 1 | TRS-POL-603900 | 19 April 2019 | 19 April 2025 | 20 | 19 April 2019 | CUST-802812 | 1330929.44 | 24594.09 | Quarterly | 7587.61 | AGT-6578 | April | Q2 | 2019 | 19 April 2020 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 98376.36 | 1967527.2 | 6 | 590258.16 | 1377269.04 | 2154442.284 | 6.69% | 186915.084 | 19-04-2039 | 0 | 0 | 1 |
| 2 | TRS-POL-336174 | 12 August 2019 | 12 August 2025 | 20 | 12 August 2019 | CUST-541584 | 714993.62 | 76687.52 | Quarterly | 4288.23 | AGT-6578 | August | Q3 | 2019 | 12 August 2020 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 306750.08 | 6135001.6 | 6 | 1840500.48 | 4294501.12 | 6717826.752 | 6.69% | 582825.152 | 12-08-2039 | 0 | 0 | 1 |
| 3 | TRS-POL-745853 | 14 November 2016 | 14 November 2025 | 20 | 14 November 2016 | CUST-192788 | 270848.26 | 18826.75 | Quarterly | 6725.00 | AGT-6578 | November | Q4 | 2016 | 14 November 2017 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 75307.00 | 1506140.0 | 9 | 677763.00 | 828377.00 | 1619100.500 | 4.45% | 112960.500 | 14-11-2036 | 0 | 0 | 1 |
| 4 | TRS-POL-799138 | 09 June 2017 | 09 June 2025 | 20 | 09 June 2017 | CUST-221834 | 1885143.74 | 93979.29 | Quarterly | 5369.76 | AGT-6578 | June | Q2 | 2017 | 09 June 2018 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 375917.16 | 7518343.2 | 8 | 3007337.28 | 4511005.92 | 8232585.804 | 5.16% | 714242.604 | 09-06-2037 | 0 | 0 | 1 |
| 5 | TRS-POL-161147 | 08 March 2024 | 08 March 2024 | 20 | 20 April 2025 | CUST-114960 | 954941.34 | 10426.03 | Quarterly | 5087.14 | AGT-6578 | April | Q2 | 2025 | 20 April 2026 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 41704.12 | 834082.4 | 0 | 0.00 | 834082.40 | 896638.580 | NaN | 62556.180 | 08-03-2044 | 0 | 0 | 0 |
| 6 | TRS-POL-765871 | 12 May 2021 | 12 May 2025 | 20 | 12 May 2021 | CUST-360696 | 1765342.50 | 28163.15 | Quarterly | 825.98 | AGT-6578 | May | Q2 | 2021 | 12 May 2022 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 112652.60 | 2253052.0 | 4 | 450610.40 | 1802441.60 | 2467091.940 | 8.87% | 214039.940 | 12-05-2041 | 0 | 0 | 0 |
| 7 | TRS-POL-746555 | 15 February 2021 | 15 February 2025 | 20 | 15 February 2021 | CUST-876796 | 503342.80 | 37813.58 | Quarterly | 6045.14 | AGT-6578 | February | Q1 | 2021 | 15 February 2022 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 151254.32 | 3025086.4 | 4 | 605017.28 | 2420069.12 | 3312469.608 | 8.87% | 287383.208 | 15-02-2041 | 0 | 0 | 0 |
| 8 | TRS-POL-110143 | 31 July 2020 | 31 July 2025 | 20 | 31 July 2020 | CUST-416715 | 1994578.66 | 49539.75 | Quarterly | 3456.37 | AGT-6578 | July | Q3 | 2020 | 31 July 2021 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 198159.00 | 3963180.0 | 5 | 990795.00 | 2972385.00 | 4339682.100 | 7.66% | 376502.100 | 31-07-2040 | 0 | 0 | 1 |
| 9 | TRS-POL-742236 | 25 May 2017 | 25 May 2025 | 20 | 25 May 2017 | CUST-964599 | 1170360.87 | 54964.27 | Quarterly | 2759.54 | AGT-6578 | May | Q2 | 2017 | 25 May 2018 | TR-UNCD988 | UGP-TRCD-9834 | Active | Delhi | RMN7A3X1 | ZMN8K2L1 | 219857.08 | 4397141.6 | 8 | 1758856.64 | 2638284.96 | 4814870.052 | 5.16% | 417728.452 | 25-05-2037 | 0 | 0 | 1 |
| Policy Number | Start Date | Last Paid Date | Tenure (Years) | Date of Purchase | Customer ID | Sum Assured INR/Coverage Amount | Premium Amount | Payment Frequency | Underwriting expenses | Sales Agent Code | Purchase Month | Purchase Quarter | Purchase Year | Policy Anniversary Date | Policy Type Code | Policy Code | Policy Status | State | RM ID | Zonal Manager ID | Total Annual Premium | Total Premium Amount | Premium Payment Duration | Total Premium paid | Total Premium Payable | Maturity Amount | Annualized ROI (%) | profit/gain | Tenure Date | MaturedIn 5 years | MaturedIn 10 years | MaturedIn 15 years | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9990 | TRS-POL-913836 | 28 August 2021 | 28 August 2021 | 12 | 28 August 2021 | CUST-399205 | 606829.65 | 11862.97 | Quarterly | 5943.52 | AGT-4456 | August | Q3 | 2021 | 28 August 2022 | TR-ENDD989 | STP-TRCD-9812 | Lapsed | Bihar | RMC9F7L5 | ZMN8K2L1 | 47451.88 | 569422.56 | 0 | 0.00 | 569422.56 | 0.0 | NaN | -569422.56 | 28-08-2033 | 0 | 1 | 0 |
| 9991 | TRS-POL-752455 | 28 March 2016 | 28 March 2016 | 12 | 28 March 2016 | CUST-639678 | 604946.71 | 73364.96 | Annually | 6338.24 | AGT-4456 | March | Q1 | 2016 | 28 March 2017 | TR-ENDD989 | STP-TRCD-9812 | Claimed | Bihar | RMC9F7L5 | ZMN8K2L1 | 73364.96 | 880379.52 | 0 | 0.00 | 880379.52 | 0.0 | NaN | -880379.52 | 28-03-2028 | 1 | 0 | 0 |
| 9992 | TRS-POL-981638 | 10 June 2016 | 10 June 2016 | 12 | 10 June 2016 | CUST-248477 | 1543871.18 | 39037.94 | Monthly | 4564.53 | AGT-4456 | June | Q2 | 2016 | 10 June 2017 | TR-ENDD989 | STP-TRCD-9812 | Claimed | Bihar | RMC9F7L5 | ZMN8K2L1 | 468455.28 | 5621463.36 | 0 | 0.00 | 5621463.36 | 0.0 | NaN | -5621463.36 | 10-06-2028 | 1 | 0 | 0 |
| 9993 | TRS-POL-655995 | 21 July 2017 | 21 July 2020 | 15 | 21 July 2017 | CUST-348336 | 1198318.34 | 56748.62 | Annually | 3099.95 | AGT-4456 | July | Q3 | 2017 | 21 July 2018 | TR-UNCD988 | RSE-TRCD-9856 | Lapsed | Bihar | RMC9F7L5 | ZMN8K2L1 | 56748.62 | 851229.30 | 3 | 170245.86 | 680983.44 | 0.0 | -100.00% | -851229.30 | 21-07-2032 | 0 | 1 | 0 |
| 9994 | TRS-POL-274989 | 21 March 2022 | 21 March 2022 | 22 | 21 March 2022 | CUST-516693 | 608369.79 | 19599.33 | Quarterly | 2347.60 | AGT-4456 | March | Q1 | 2022 | 21 March 2023 | TR-WHCD968 | GWB-TRCD-9833 | Lapsed | Bihar | RMC9F7L5 | ZMN8K2L1 | 78397.32 | 1724741.04 | 0 | 0.00 | 1724741.04 | 0.0 | NaN | -1724741.04 | 21-03-2044 | 0 | 0 | 0 |
| 9995 | TRS-POL-559584 | 19 July 2024 | 19 July 2024 | 12 | 19 July 2024 | CUST-923180 | 349590.39 | 37745.08 | Monthly | 4595.54 | AGT-4456 | July | Q3 | 2024 | 19 July 2025 | TR-ENDD989 | STP-TRCD-9812 | Claimed | Bihar | RMC9F7L5 | ZMN8K2L1 | 452940.96 | 5435291.52 | 0 | 0.00 | 5435291.52 | 0.0 | NaN | -5435291.52 | 19-07-2036 | 0 | 0 | 1 |
| 9996 | TRS-POL-841642 | 12 November 2020 | 12 November 2020 | 12 | 12 November 2020 | CUST-741949 | 296895.39 | 15641.59 | Annually | 1729.38 | AGT-4456 | November | Q4 | 2020 | 12 November 2021 | TR-ENDD989 | STP-TRCD-9812 | Claimed | Bihar | RMC9F7L5 | ZMN8K2L1 | 15641.59 | 187699.08 | 0 | 0.00 | 187699.08 | 0.0 | NaN | -187699.08 | 12-11-2032 | 0 | 1 | 0 |
| 9997 | TRS-POL-957843 | 08 August 2016 | 08 August 2019 | 22 | 08 August 2016 | CUST-939199 | 1714215.96 | 62690.51 | Annually | 2547.18 | AGT-4456 | August | Q3 | 2016 | 08 August 2017 | TR-WHCD968 | GWB-TRCD-9833 | Lapsed | Bihar | RMC9F7L5 | ZMN8K2L1 | 62690.51 | 1379191.22 | 3 | 188071.53 | 1191119.69 | 0.0 | -100.00% | -1379191.22 | 08-08-2038 | 0 | 0 | 1 |
| 9998 | TRS-POL-919446 | 01 March 2022 | 01 March 2022 | 15 | 01 March 2022 | CUST-451502 | 626672.09 | 22644.85 | Quarterly | 2717.31 | AGT-4456 | March | Q1 | 2022 | 01 March 2023 | TR-UNCD988 | RSE-TRCD-9856 | Claimed | Bihar | RMC9F7L5 | ZMN8K2L1 | 90579.40 | 1358691.00 | 0 | 0.00 | 1358691.00 | 0.0 | NaN | -1358691.00 | 01-03-2037 | 0 | 0 | 1 |
| 9999 | TRS-POL-180401 | 26 December 2021 | 26 December 2021 | 12 | 26 December 2021 | CUST-703127 | 1866944.96 | 28902.43 | Monthly | 6965.41 | AGT-4456 | December | Q4 | 2021 | 26 December 2022 | TR-ENDD989 | STP-TRCD-9812 | Lapsed | Bihar | RMC9F7L5 | ZMN8K2L1 | 346829.16 | 4161949.92 | 0 | 0.00 | 4161949.92 | 0.0 | NaN | -4161949.92 | 26-12-2033 | 0 | 1 | 0 |